﻿CREATE PROCEDURE [dbo].[Hogar_AsisteComedorViandaDias_ObtenerTodas]   
 @IntegranteId INT
AS 
BEGIN

/*****************************************************************************************************************************************/
-- Author: Carlos Mendoza
-- Purpose:   obtener todas los dias que asiste un integrante a comedor o vianda 
-- Returns:    AsisteActividadDias
/*****************************************************************************************************************************************/ 
	
	
	
		SELECT  [IntegranteId],
				[ActividadId],
				[DiaSemanaId]
		FROM	[dbo].[AsisteComedorViandaDias] WITH (NOLOCK)
		WHERE	[IntegranteId] = @IntegranteId
		ORDER BY [ActividadId], [DiaSemanaId]
	
END